package com.hjb.service.domain.SiteUserOrder;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SiteUserOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SiteUserOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeIsNull() {
            addCriterion("platform_pay_type is null");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeIsNotNull() {
            addCriterion("platform_pay_type is not null");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeEqualTo(Integer value) {
            addCriterion("platform_pay_type =", value, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeNotEqualTo(Integer value) {
            addCriterion("platform_pay_type <>", value, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeGreaterThan(Integer value) {
            addCriterion("platform_pay_type >", value, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("platform_pay_type >=", value, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeLessThan(Integer value) {
            addCriterion("platform_pay_type <", value, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeLessThanOrEqualTo(Integer value) {
            addCriterion("platform_pay_type <=", value, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeIn(List<Integer> values) {
            addCriterion("platform_pay_type in", values, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeNotIn(List<Integer> values) {
            addCriterion("platform_pay_type not in", values, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeBetween(Integer value1, Integer value2) {
            addCriterion("platform_pay_type between", value1, value2, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPlatformPayTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("platform_pay_type not between", value1, value2, "platformPayType");
            return (Criteria) this;
        }

        public Criteria andPayTermIsNull() {
            addCriterion("pay_term is null");
            return (Criteria) this;
        }

        public Criteria andPayTermIsNotNull() {
            addCriterion("pay_term is not null");
            return (Criteria) this;
        }

        public Criteria andPayTermEqualTo(Integer value) {
            addCriterion("pay_term =", value, "payTerm");
            return (Criteria) this;
        }

        public Criteria andPayTermNotEqualTo(Integer value) {
            addCriterion("pay_term <>", value, "payTerm");
            return (Criteria) this;
        }

        public Criteria andPayTermGreaterThan(Integer value) {
            addCriterion("pay_term >", value, "payTerm");
            return (Criteria) this;
        }

        public Criteria andPayTermGreaterThanOrEqualTo(Integer value) {
            addCriterion("pay_term >=", value, "payTerm");
            return (Criteria) this;
        }

        public Criteria andPayTermLessThan(Integer value) {
            addCriterion("pay_term <", value, "payTerm");
            return (Criteria) this;
        }

        public Criteria andPayTermLessThanOrEqualTo(Integer value) {
            addCriterion("pay_term <=", value, "payTerm");
            return (Criteria) this;
        }

        public Criteria andPayTermIn(List<Integer> values) {
            addCriterion("pay_term in", values, "payTerm");
            return (Criteria) this;
        }

        public Criteria andPayTermNotIn(List<Integer> values) {
            addCriterion("pay_term not in", values, "payTerm");
            return (Criteria) this;
        }

        public Criteria andPayTermBetween(Integer value1, Integer value2) {
            addCriterion("pay_term between", value1, value2, "payTerm");
            return (Criteria) this;
        }

        public Criteria andPayTermNotBetween(Integer value1, Integer value2) {
            addCriterion("pay_term not between", value1, value2, "payTerm");
            return (Criteria) this;
        }

        public Criteria andChangeNoIsNull() {
            addCriterion("change_no is null");
            return (Criteria) this;
        }

        public Criteria andChangeNoIsNotNull() {
            addCriterion("change_no is not null");
            return (Criteria) this;
        }

        public Criteria andChangeNoEqualTo(String value) {
            addCriterion("change_no =", value, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoNotEqualTo(String value) {
            addCriterion("change_no <>", value, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoGreaterThan(String value) {
            addCriterion("change_no >", value, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoGreaterThanOrEqualTo(String value) {
            addCriterion("change_no >=", value, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoLessThan(String value) {
            addCriterion("change_no <", value, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoLessThanOrEqualTo(String value) {
            addCriterion("change_no <=", value, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoLike(String value) {
            addCriterion("change_no like", value, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoNotLike(String value) {
            addCriterion("change_no not like", value, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoIn(List<String> values) {
            addCriterion("change_no in", values, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoNotIn(List<String> values) {
            addCriterion("change_no not in", values, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoBetween(String value1, String value2) {
            addCriterion("change_no between", value1, value2, "changeNo");
            return (Criteria) this;
        }

        public Criteria andChangeNoNotBetween(String value1, String value2) {
            addCriterion("change_no not between", value1, value2, "changeNo");
            return (Criteria) this;
        }

        public Criteria andReturnTypeIsNull() {
            addCriterion("return_type is null");
            return (Criteria) this;
        }

        public Criteria andReturnTypeIsNotNull() {
            addCriterion("return_type is not null");
            return (Criteria) this;
        }

        public Criteria andReturnTypeEqualTo(String value) {
            addCriterion("return_type =", value, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeNotEqualTo(String value) {
            addCriterion("return_type <>", value, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeGreaterThan(String value) {
            addCriterion("return_type >", value, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeGreaterThanOrEqualTo(String value) {
            addCriterion("return_type >=", value, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeLessThan(String value) {
            addCriterion("return_type <", value, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeLessThanOrEqualTo(String value) {
            addCriterion("return_type <=", value, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeLike(String value) {
            addCriterion("return_type like", value, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeNotLike(String value) {
            addCriterion("return_type not like", value, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeIn(List<String> values) {
            addCriterion("return_type in", values, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeNotIn(List<String> values) {
            addCriterion("return_type not in", values, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeBetween(String value1, String value2) {
            addCriterion("return_type between", value1, value2, "returnType");
            return (Criteria) this;
        }

        public Criteria andReturnTypeNotBetween(String value1, String value2) {
            addCriterion("return_type not between", value1, value2, "returnType");
            return (Criteria) this;
        }

        public Criteria andApplyDateIsNull() {
            addCriterion("apply_date is null");
            return (Criteria) this;
        }

        public Criteria andApplyDateIsNotNull() {
            addCriterion("apply_date is not null");
            return (Criteria) this;
        }

        public Criteria andApplyDateEqualTo(Integer value) {
            addCriterion("apply_date =", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateNotEqualTo(Integer value) {
            addCriterion("apply_date <>", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateGreaterThan(Integer value) {
            addCriterion("apply_date >", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateGreaterThanOrEqualTo(Integer value) {
            addCriterion("apply_date >=", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateLessThan(Integer value) {
            addCriterion("apply_date <", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateLessThanOrEqualTo(Integer value) {
            addCriterion("apply_date <=", value, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateIn(List<Integer> values) {
            addCriterion("apply_date in", values, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateNotIn(List<Integer> values) {
            addCriterion("apply_date not in", values, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateBetween(Integer value1, Integer value2) {
            addCriterion("apply_date between", value1, value2, "applyDate");
            return (Criteria) this;
        }

        public Criteria andApplyDateNotBetween(Integer value1, Integer value2) {
            addCriterion("apply_date not between", value1, value2, "applyDate");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoIsNull() {
            addCriterion("refuse_info is null");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoIsNotNull() {
            addCriterion("refuse_info is not null");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoEqualTo(String value) {
            addCriterion("refuse_info =", value, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoNotEqualTo(String value) {
            addCriterion("refuse_info <>", value, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoGreaterThan(String value) {
            addCriterion("refuse_info >", value, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoGreaterThanOrEqualTo(String value) {
            addCriterion("refuse_info >=", value, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoLessThan(String value) {
            addCriterion("refuse_info <", value, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoLessThanOrEqualTo(String value) {
            addCriterion("refuse_info <=", value, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoLike(String value) {
            addCriterion("refuse_info like", value, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoNotLike(String value) {
            addCriterion("refuse_info not like", value, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoIn(List<String> values) {
            addCriterion("refuse_info in", values, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoNotIn(List<String> values) {
            addCriterion("refuse_info not in", values, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoBetween(String value1, String value2) {
            addCriterion("refuse_info between", value1, value2, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseInfoNotBetween(String value1, String value2) {
            addCriterion("refuse_info not between", value1, value2, "refuseInfo");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkIsNull() {
            addCriterion("refuse_remark is null");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkIsNotNull() {
            addCriterion("refuse_remark is not null");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkEqualTo(String value) {
            addCriterion("refuse_remark =", value, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkNotEqualTo(String value) {
            addCriterion("refuse_remark <>", value, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkGreaterThan(String value) {
            addCriterion("refuse_remark >", value, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("refuse_remark >=", value, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkLessThan(String value) {
            addCriterion("refuse_remark <", value, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkLessThanOrEqualTo(String value) {
            addCriterion("refuse_remark <=", value, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkLike(String value) {
            addCriterion("refuse_remark like", value, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkNotLike(String value) {
            addCriterion("refuse_remark not like", value, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkIn(List<String> values) {
            addCriterion("refuse_remark in", values, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkNotIn(List<String> values) {
            addCriterion("refuse_remark not in", values, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkBetween(String value1, String value2) {
            addCriterion("refuse_remark between", value1, value2, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRefuseRemarkNotBetween(String value1, String value2) {
            addCriterion("refuse_remark not between", value1, value2, "refuseRemark");
            return (Criteria) this;
        }

        public Criteria andRateIsNull() {
            addCriterion("rate is null");
            return (Criteria) this;
        }

        public Criteria andRateIsNotNull() {
            addCriterion("rate is not null");
            return (Criteria) this;
        }

        public Criteria andRateEqualTo(BigDecimal value) {
            addCriterion("rate =", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotEqualTo(BigDecimal value) {
            addCriterion("rate <>", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateGreaterThan(BigDecimal value) {
            addCriterion("rate >", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("rate >=", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateLessThan(BigDecimal value) {
            addCriterion("rate <", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("rate <=", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateIn(List<BigDecimal> values) {
            addCriterion("rate in", values, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotIn(List<BigDecimal> values) {
            addCriterion("rate not in", values, "rate");
            return (Criteria) this;
        }

        public Criteria andRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("rate between", value1, value2, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("rate not between", value1, value2, "rate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateIsNull() {
            addCriterion("discount_rate is null");
            return (Criteria) this;
        }

        public Criteria andDiscountRateIsNotNull() {
            addCriterion("discount_rate is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountRateEqualTo(BigDecimal value) {
            addCriterion("discount_rate =", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateNotEqualTo(BigDecimal value) {
            addCriterion("discount_rate <>", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateGreaterThan(BigDecimal value) {
            addCriterion("discount_rate >", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discount_rate >=", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateLessThan(BigDecimal value) {
            addCriterion("discount_rate <", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discount_rate <=", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateIn(List<BigDecimal> values) {
            addCriterion("discount_rate in", values, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateNotIn(List<BigDecimal> values) {
            addCriterion("discount_rate not in", values, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount_rate between", value1, value2, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount_rate not between", value1, value2, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateIsNull() {
            addCriterion("delay_rate is null");
            return (Criteria) this;
        }

        public Criteria andDelayRateIsNotNull() {
            addCriterion("delay_rate is not null");
            return (Criteria) this;
        }

        public Criteria andDelayRateEqualTo(BigDecimal value) {
            addCriterion("delay_rate =", value, "delayRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateNotEqualTo(BigDecimal value) {
            addCriterion("delay_rate <>", value, "delayRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateGreaterThan(BigDecimal value) {
            addCriterion("delay_rate >", value, "delayRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("delay_rate >=", value, "delayRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateLessThan(BigDecimal value) {
            addCriterion("delay_rate <", value, "delayRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("delay_rate <=", value, "delayRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateIn(List<BigDecimal> values) {
            addCriterion("delay_rate in", values, "delayRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateNotIn(List<BigDecimal> values) {
            addCriterion("delay_rate not in", values, "delayRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("delay_rate between", value1, value2, "delayRate");
            return (Criteria) this;
        }

        public Criteria andDelayRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("delay_rate not between", value1, value2, "delayRate");
            return (Criteria) this;
        }

        public Criteria andCashIsNull() {
            addCriterion("cash is null");
            return (Criteria) this;
        }

        public Criteria andCashIsNotNull() {
            addCriterion("cash is not null");
            return (Criteria) this;
        }

        public Criteria andCashEqualTo(BigDecimal value) {
            addCriterion("cash =", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashNotEqualTo(BigDecimal value) {
            addCriterion("cash <>", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashGreaterThan(BigDecimal value) {
            addCriterion("cash >", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cash >=", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashLessThan(BigDecimal value) {
            addCriterion("cash <", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cash <=", value, "cash");
            return (Criteria) this;
        }

        public Criteria andCashIn(List<BigDecimal> values) {
            addCriterion("cash in", values, "cash");
            return (Criteria) this;
        }

        public Criteria andCashNotIn(List<BigDecimal> values) {
            addCriterion("cash not in", values, "cash");
            return (Criteria) this;
        }

        public Criteria andCashBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cash between", value1, value2, "cash");
            return (Criteria) this;
        }

        public Criteria andCashNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cash not between", value1, value2, "cash");
            return (Criteria) this;
        }

        public Criteria andTenancyNameIsNull() {
            addCriterion("tenancy_name is null");
            return (Criteria) this;
        }

        public Criteria andTenancyNameIsNotNull() {
            addCriterion("tenancy_name is not null");
            return (Criteria) this;
        }

        public Criteria andTenancyNameEqualTo(String value) {
            addCriterion("tenancy_name =", value, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameNotEqualTo(String value) {
            addCriterion("tenancy_name <>", value, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameGreaterThan(String value) {
            addCriterion("tenancy_name >", value, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameGreaterThanOrEqualTo(String value) {
            addCriterion("tenancy_name >=", value, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameLessThan(String value) {
            addCriterion("tenancy_name <", value, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameLessThanOrEqualTo(String value) {
            addCriterion("tenancy_name <=", value, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameLike(String value) {
            addCriterion("tenancy_name like", value, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameNotLike(String value) {
            addCriterion("tenancy_name not like", value, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameIn(List<String> values) {
            addCriterion("tenancy_name in", values, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameNotIn(List<String> values) {
            addCriterion("tenancy_name not in", values, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameBetween(String value1, String value2) {
            addCriterion("tenancy_name between", value1, value2, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyNameNotBetween(String value1, String value2) {
            addCriterion("tenancy_name not between", value1, value2, "tenancyName");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileIsNull() {
            addCriterion("tenancy_mobile is null");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileIsNotNull() {
            addCriterion("tenancy_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileEqualTo(String value) {
            addCriterion("tenancy_mobile =", value, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileNotEqualTo(String value) {
            addCriterion("tenancy_mobile <>", value, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileGreaterThan(String value) {
            addCriterion("tenancy_mobile >", value, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileGreaterThanOrEqualTo(String value) {
            addCriterion("tenancy_mobile >=", value, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileLessThan(String value) {
            addCriterion("tenancy_mobile <", value, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileLessThanOrEqualTo(String value) {
            addCriterion("tenancy_mobile <=", value, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileLike(String value) {
            addCriterion("tenancy_mobile like", value, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileNotLike(String value) {
            addCriterion("tenancy_mobile not like", value, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileIn(List<String> values) {
            addCriterion("tenancy_mobile in", values, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileNotIn(List<String> values) {
            addCriterion("tenancy_mobile not in", values, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileBetween(String value1, String value2) {
            addCriterion("tenancy_mobile between", value1, value2, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyMobileNotBetween(String value1, String value2) {
            addCriterion("tenancy_mobile not between", value1, value2, "tenancyMobile");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardIsNull() {
            addCriterion("tenancy_idcard is null");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardIsNotNull() {
            addCriterion("tenancy_idcard is not null");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardEqualTo(String value) {
            addCriterion("tenancy_idcard =", value, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardNotEqualTo(String value) {
            addCriterion("tenancy_idcard <>", value, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardGreaterThan(String value) {
            addCriterion("tenancy_idcard >", value, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardGreaterThanOrEqualTo(String value) {
            addCriterion("tenancy_idcard >=", value, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardLessThan(String value) {
            addCriterion("tenancy_idcard <", value, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardLessThanOrEqualTo(String value) {
            addCriterion("tenancy_idcard <=", value, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardLike(String value) {
            addCriterion("tenancy_idcard like", value, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardNotLike(String value) {
            addCriterion("tenancy_idcard not like", value, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardIn(List<String> values) {
            addCriterion("tenancy_idcard in", values, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardNotIn(List<String> values) {
            addCriterion("tenancy_idcard not in", values, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardBetween(String value1, String value2) {
            addCriterion("tenancy_idcard between", value1, value2, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyIdcardNotBetween(String value1, String value2) {
            addCriterion("tenancy_idcard not between", value1, value2, "tenancyIdcard");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeIsNull() {
            addCriterion("tenancy_type is null");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeIsNotNull() {
            addCriterion("tenancy_type is not null");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeEqualTo(Integer value) {
            addCriterion("tenancy_type =", value, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeNotEqualTo(Integer value) {
            addCriterion("tenancy_type <>", value, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeGreaterThan(Integer value) {
            addCriterion("tenancy_type >", value, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("tenancy_type >=", value, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeLessThan(Integer value) {
            addCriterion("tenancy_type <", value, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeLessThanOrEqualTo(Integer value) {
            addCriterion("tenancy_type <=", value, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeIn(List<Integer> values) {
            addCriterion("tenancy_type in", values, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeNotIn(List<Integer> values) {
            addCriterion("tenancy_type not in", values, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeBetween(Integer value1, Integer value2) {
            addCriterion("tenancy_type between", value1, value2, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andTenancyTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("tenancy_type not between", value1, value2, "tenancyType");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("start_time is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("start_time is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(Date value) {
            addCriterion("start_time =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(Date value) {
            addCriterion("start_time <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(Date value) {
            addCriterion("start_time >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("start_time >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(Date value) {
            addCriterion("start_time <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("start_time <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<Date> values) {
            addCriterion("start_time in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<Date> values) {
            addCriterion("start_time not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(Date value1, Date value2) {
            addCriterion("start_time between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("start_time not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andFeeTypeIsNull() {
            addCriterion("fee_type is null");
            return (Criteria) this;
        }

        public Criteria andFeeTypeIsNotNull() {
            addCriterion("fee_type is not null");
            return (Criteria) this;
        }

        public Criteria andFeeTypeEqualTo(Integer value) {
            addCriterion("fee_type =", value, "feeType");
            return (Criteria) this;
        }

        public Criteria andFeeTypeNotEqualTo(Integer value) {
            addCriterion("fee_type <>", value, "feeType");
            return (Criteria) this;
        }

        public Criteria andFeeTypeGreaterThan(Integer value) {
            addCriterion("fee_type >", value, "feeType");
            return (Criteria) this;
        }

        public Criteria andFeeTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("fee_type >=", value, "feeType");
            return (Criteria) this;
        }

        public Criteria andFeeTypeLessThan(Integer value) {
            addCriterion("fee_type <", value, "feeType");
            return (Criteria) this;
        }

        public Criteria andFeeTypeLessThanOrEqualTo(Integer value) {
            addCriterion("fee_type <=", value, "feeType");
            return (Criteria) this;
        }

        public Criteria andFeeTypeIn(List<Integer> values) {
            addCriterion("fee_type in", values, "feeType");
            return (Criteria) this;
        }

        public Criteria andFeeTypeNotIn(List<Integer> values) {
            addCriterion("fee_type not in", values, "feeType");
            return (Criteria) this;
        }

        public Criteria andFeeTypeBetween(Integer value1, Integer value2) {
            addCriterion("fee_type between", value1, value2, "feeType");
            return (Criteria) this;
        }

        public Criteria andFeeTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("fee_type not between", value1, value2, "feeType");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeIsNull() {
            addCriterion("first_paytype is null");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeIsNotNull() {
            addCriterion("first_paytype is not null");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeEqualTo(Integer value) {
            addCriterion("first_paytype =", value, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeNotEqualTo(Integer value) {
            addCriterion("first_paytype <>", value, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeGreaterThan(Integer value) {
            addCriterion("first_paytype >", value, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("first_paytype >=", value, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeLessThan(Integer value) {
            addCriterion("first_paytype <", value, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeLessThanOrEqualTo(Integer value) {
            addCriterion("first_paytype <=", value, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeIn(List<Integer> values) {
            addCriterion("first_paytype in", values, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeNotIn(List<Integer> values) {
            addCriterion("first_paytype not in", values, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeBetween(Integer value1, Integer value2) {
            addCriterion("first_paytype between", value1, value2, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andFirstPaytypeNotBetween(Integer value1, Integer value2) {
            addCriterion("first_paytype not between", value1, value2, "firstPaytype");
            return (Criteria) this;
        }

        public Criteria andHouseNameIsNull() {
            addCriterion("house_name is null");
            return (Criteria) this;
        }

        public Criteria andHouseNameIsNotNull() {
            addCriterion("house_name is not null");
            return (Criteria) this;
        }

        public Criteria andHouseNameEqualTo(String value) {
            addCriterion("house_name =", value, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameNotEqualTo(String value) {
            addCriterion("house_name <>", value, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameGreaterThan(String value) {
            addCriterion("house_name >", value, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameGreaterThanOrEqualTo(String value) {
            addCriterion("house_name >=", value, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameLessThan(String value) {
            addCriterion("house_name <", value, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameLessThanOrEqualTo(String value) {
            addCriterion("house_name <=", value, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameLike(String value) {
            addCriterion("house_name like", value, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameNotLike(String value) {
            addCriterion("house_name not like", value, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameIn(List<String> values) {
            addCriterion("house_name in", values, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameNotIn(List<String> values) {
            addCriterion("house_name not in", values, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameBetween(String value1, String value2) {
            addCriterion("house_name between", value1, value2, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseNameNotBetween(String value1, String value2) {
            addCriterion("house_name not between", value1, value2, "houseName");
            return (Criteria) this;
        }

        public Criteria andHouseCodeIsNull() {
            addCriterion("house_code is null");
            return (Criteria) this;
        }

        public Criteria andHouseCodeIsNotNull() {
            addCriterion("house_code is not null");
            return (Criteria) this;
        }

        public Criteria andHouseCodeEqualTo(String value) {
            addCriterion("house_code =", value, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeNotEqualTo(String value) {
            addCriterion("house_code <>", value, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeGreaterThan(String value) {
            addCriterion("house_code >", value, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeGreaterThanOrEqualTo(String value) {
            addCriterion("house_code >=", value, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeLessThan(String value) {
            addCriterion("house_code <", value, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeLessThanOrEqualTo(String value) {
            addCriterion("house_code <=", value, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeLike(String value) {
            addCriterion("house_code like", value, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeNotLike(String value) {
            addCriterion("house_code not like", value, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeIn(List<String> values) {
            addCriterion("house_code in", values, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeNotIn(List<String> values) {
            addCriterion("house_code not in", values, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeBetween(String value1, String value2) {
            addCriterion("house_code between", value1, value2, "houseCode");
            return (Criteria) this;
        }

        public Criteria andHouseCodeNotBetween(String value1, String value2) {
            addCriterion("house_code not between", value1, value2, "houseCode");
            return (Criteria) this;
        }

        public Criteria andRoomNumIsNull() {
            addCriterion("room_num is null");
            return (Criteria) this;
        }

        public Criteria andRoomNumIsNotNull() {
            addCriterion("room_num is not null");
            return (Criteria) this;
        }

        public Criteria andRoomNumEqualTo(String value) {
            addCriterion("room_num =", value, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumNotEqualTo(String value) {
            addCriterion("room_num <>", value, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumGreaterThan(String value) {
            addCriterion("room_num >", value, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumGreaterThanOrEqualTo(String value) {
            addCriterion("room_num >=", value, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumLessThan(String value) {
            addCriterion("room_num <", value, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumLessThanOrEqualTo(String value) {
            addCriterion("room_num <=", value, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumLike(String value) {
            addCriterion("room_num like", value, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumNotLike(String value) {
            addCriterion("room_num not like", value, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumIn(List<String> values) {
            addCriterion("room_num in", values, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumNotIn(List<String> values) {
            addCriterion("room_num not in", values, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumBetween(String value1, String value2) {
            addCriterion("room_num between", value1, value2, "roomNum");
            return (Criteria) this;
        }

        public Criteria andRoomNumNotBetween(String value1, String value2) {
            addCriterion("room_num not between", value1, value2, "roomNum");
            return (Criteria) this;
        }

        public Criteria andSettleDateIsNull() {
            addCriterion("settle_date is null");
            return (Criteria) this;
        }

        public Criteria andSettleDateIsNotNull() {
            addCriterion("settle_date is not null");
            return (Criteria) this;
        }

        public Criteria andSettleDateEqualTo(Integer value) {
            addCriterion("settle_date =", value, "settleDate");
            return (Criteria) this;
        }

        public Criteria andSettleDateNotEqualTo(Integer value) {
            addCriterion("settle_date <>", value, "settleDate");
            return (Criteria) this;
        }

        public Criteria andSettleDateGreaterThan(Integer value) {
            addCriterion("settle_date >", value, "settleDate");
            return (Criteria) this;
        }

        public Criteria andSettleDateGreaterThanOrEqualTo(Integer value) {
            addCriterion("settle_date >=", value, "settleDate");
            return (Criteria) this;
        }

        public Criteria andSettleDateLessThan(Integer value) {
            addCriterion("settle_date <", value, "settleDate");
            return (Criteria) this;
        }

        public Criteria andSettleDateLessThanOrEqualTo(Integer value) {
            addCriterion("settle_date <=", value, "settleDate");
            return (Criteria) this;
        }

        public Criteria andSettleDateIn(List<Integer> values) {
            addCriterion("settle_date in", values, "settleDate");
            return (Criteria) this;
        }

        public Criteria andSettleDateNotIn(List<Integer> values) {
            addCriterion("settle_date not in", values, "settleDate");
            return (Criteria) this;
        }

        public Criteria andSettleDateBetween(Integer value1, Integer value2) {
            addCriterion("settle_date between", value1, value2, "settleDate");
            return (Criteria) this;
        }

        public Criteria andSettleDateNotBetween(Integer value1, Integer value2) {
            addCriterion("settle_date not between", value1, value2, "settleDate");
            return (Criteria) this;
        }

        public Criteria andInfoIsNull() {
            addCriterion("info is null");
            return (Criteria) this;
        }

        public Criteria andInfoIsNotNull() {
            addCriterion("info is not null");
            return (Criteria) this;
        }

        public Criteria andInfoEqualTo(String value) {
            addCriterion("info =", value, "info");
            return (Criteria) this;
        }

        public Criteria andInfoNotEqualTo(String value) {
            addCriterion("info <>", value, "info");
            return (Criteria) this;
        }

        public Criteria andInfoGreaterThan(String value) {
            addCriterion("info >", value, "info");
            return (Criteria) this;
        }

        public Criteria andInfoGreaterThanOrEqualTo(String value) {
            addCriterion("info >=", value, "info");
            return (Criteria) this;
        }

        public Criteria andInfoLessThan(String value) {
            addCriterion("info <", value, "info");
            return (Criteria) this;
        }

        public Criteria andInfoLessThanOrEqualTo(String value) {
            addCriterion("info <=", value, "info");
            return (Criteria) this;
        }

        public Criteria andInfoLike(String value) {
            addCriterion("info like", value, "info");
            return (Criteria) this;
        }

        public Criteria andInfoNotLike(String value) {
            addCriterion("info not like", value, "info");
            return (Criteria) this;
        }

        public Criteria andInfoIn(List<String> values) {
            addCriterion("info in", values, "info");
            return (Criteria) this;
        }

        public Criteria andInfoNotIn(List<String> values) {
            addCriterion("info not in", values, "info");
            return (Criteria) this;
        }

        public Criteria andInfoBetween(String value1, String value2) {
            addCriterion("info between", value1, value2, "info");
            return (Criteria) this;
        }

        public Criteria andInfoNotBetween(String value1, String value2) {
            addCriterion("info not between", value1, value2, "info");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlIsNull() {
            addCriterion("qrcode_url is null");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlIsNotNull() {
            addCriterion("qrcode_url is not null");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlEqualTo(String value) {
            addCriterion("qrcode_url =", value, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlNotEqualTo(String value) {
            addCriterion("qrcode_url <>", value, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlGreaterThan(String value) {
            addCriterion("qrcode_url >", value, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlGreaterThanOrEqualTo(String value) {
            addCriterion("qrcode_url >=", value, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlLessThan(String value) {
            addCriterion("qrcode_url <", value, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlLessThanOrEqualTo(String value) {
            addCriterion("qrcode_url <=", value, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlLike(String value) {
            addCriterion("qrcode_url like", value, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlNotLike(String value) {
            addCriterion("qrcode_url not like", value, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlIn(List<String> values) {
            addCriterion("qrcode_url in", values, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlNotIn(List<String> values) {
            addCriterion("qrcode_url not in", values, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlBetween(String value1, String value2) {
            addCriterion("qrcode_url between", value1, value2, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andQrcodeUrlNotBetween(String value1, String value2) {
            addCriterion("qrcode_url not between", value1, value2, "qrcodeUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlIsNull() {
            addCriterion("order_url is null");
            return (Criteria) this;
        }

        public Criteria andOrderUrlIsNotNull() {
            addCriterion("order_url is not null");
            return (Criteria) this;
        }

        public Criteria andOrderUrlEqualTo(String value) {
            addCriterion("order_url =", value, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlNotEqualTo(String value) {
            addCriterion("order_url <>", value, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlGreaterThan(String value) {
            addCriterion("order_url >", value, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlGreaterThanOrEqualTo(String value) {
            addCriterion("order_url >=", value, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlLessThan(String value) {
            addCriterion("order_url <", value, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlLessThanOrEqualTo(String value) {
            addCriterion("order_url <=", value, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlLike(String value) {
            addCriterion("order_url like", value, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlNotLike(String value) {
            addCriterion("order_url not like", value, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlIn(List<String> values) {
            addCriterion("order_url in", values, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlNotIn(List<String> values) {
            addCriterion("order_url not in", values, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlBetween(String value1, String value2) {
            addCriterion("order_url between", value1, value2, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOrderUrlNotBetween(String value1, String value2) {
            addCriterion("order_url not between", value1, value2, "orderUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlIsNull() {
            addCriterion("owner_url is null");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlIsNotNull() {
            addCriterion("owner_url is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlEqualTo(String value) {
            addCriterion("owner_url =", value, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlNotEqualTo(String value) {
            addCriterion("owner_url <>", value, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlGreaterThan(String value) {
            addCriterion("owner_url >", value, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlGreaterThanOrEqualTo(String value) {
            addCriterion("owner_url >=", value, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlLessThan(String value) {
            addCriterion("owner_url <", value, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlLessThanOrEqualTo(String value) {
            addCriterion("owner_url <=", value, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlLike(String value) {
            addCriterion("owner_url like", value, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlNotLike(String value) {
            addCriterion("owner_url not like", value, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlIn(List<String> values) {
            addCriterion("owner_url in", values, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlNotIn(List<String> values) {
            addCriterion("owner_url not in", values, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlBetween(String value1, String value2) {
            addCriterion("owner_url between", value1, value2, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andOwnerUrlNotBetween(String value1, String value2) {
            addCriterion("owner_url not between", value1, value2, "ownerUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlIsNull() {
            addCriterion("house_url is null");
            return (Criteria) this;
        }

        public Criteria andHouseUrlIsNotNull() {
            addCriterion("house_url is not null");
            return (Criteria) this;
        }

        public Criteria andHouseUrlEqualTo(String value) {
            addCriterion("house_url =", value, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlNotEqualTo(String value) {
            addCriterion("house_url <>", value, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlGreaterThan(String value) {
            addCriterion("house_url >", value, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlGreaterThanOrEqualTo(String value) {
            addCriterion("house_url >=", value, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlLessThan(String value) {
            addCriterion("house_url <", value, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlLessThanOrEqualTo(String value) {
            addCriterion("house_url <=", value, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlLike(String value) {
            addCriterion("house_url like", value, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlNotLike(String value) {
            addCriterion("house_url not like", value, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlIn(List<String> values) {
            addCriterion("house_url in", values, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlNotIn(List<String> values) {
            addCriterion("house_url not in", values, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlBetween(String value1, String value2) {
            addCriterion("house_url between", value1, value2, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andHouseUrlNotBetween(String value1, String value2) {
            addCriterion("house_url not between", value1, value2, "houseUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlIsNull() {
            addCriterion("agent_url is null");
            return (Criteria) this;
        }

        public Criteria andAgentUrlIsNotNull() {
            addCriterion("agent_url is not null");
            return (Criteria) this;
        }

        public Criteria andAgentUrlEqualTo(String value) {
            addCriterion("agent_url =", value, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlNotEqualTo(String value) {
            addCriterion("agent_url <>", value, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlGreaterThan(String value) {
            addCriterion("agent_url >", value, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlGreaterThanOrEqualTo(String value) {
            addCriterion("agent_url >=", value, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlLessThan(String value) {
            addCriterion("agent_url <", value, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlLessThanOrEqualTo(String value) {
            addCriterion("agent_url <=", value, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlLike(String value) {
            addCriterion("agent_url like", value, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlNotLike(String value) {
            addCriterion("agent_url not like", value, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlIn(List<String> values) {
            addCriterion("agent_url in", values, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlNotIn(List<String> values) {
            addCriterion("agent_url not in", values, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlBetween(String value1, String value2) {
            addCriterion("agent_url between", value1, value2, "agentUrl");
            return (Criteria) this;
        }

        public Criteria andAgentUrlNotBetween(String value1, String value2) {
            addCriterion("agent_url not between", value1, value2, "agentUrl");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}